Configure EMS Database

1. Using Microsoft SQL Server Management Studio, add a login for the EMS Active Directory security group.

2. Under the User Mapping area, map the login to your EMS database.
   

3. Add the db_datareader and db_datawriter roles.

4. Repeat Step 2 for the EMS_Master database.

5. Using Microsoft SQL Server Management Studio, execute the following statement against your EMS database:

   sp_addrolemember 'EMS_Role', 'securitygroup'
   

6. Rename the securitygroup with the name of your EMS Active Directory security group.

7. Repeat Step 5 for the EMS_Master database.